Bank Reconciliation Tables
Note: Rows and/or Tables marked with an asterisk (*) are added to Traverse Global. Rows and/or Tables marked with a negative asterisk (-*) refer to tables and/or rows that are removed in Traverse Global.
tblBrClearedTrans -- BR Cleared Transactions table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Amount | pDecimal | 13 | |||
BankId | pBankID | 10 | |||
ClearedEntryNum | int | 4 | |||
Counter | int | 4 | |||
Descr | varchar | 30 | |||
Reference | varchar | 15 | |||
SourceId | varchar | 10 | |||
TransDate | datetime | 8 | |||
TransType | smallint | 2 | |||
ts | timestamp | 8 | |||
VoidStopYn | bit | 1 |
tblBrJrnlDetail -- BR Journal Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
EntryNum | int | 4 | |||
TransID | pTransID | 8 | |||
GLAcct | pGlAcct | 40 | |||
DebitAmt | pDecimal | 13 | 0 | ||
DebitAmtFgn | pDecimal | 13 | 0 | ||
CreditAmt | pDecimal | 13 | 0 | ||
CreditAmtFgn | pDecimal | 13 | 0 | ||
Descr | nvarchar | 30 | |||
Reference | nvarchar | 15 | |||
BankIDXferTo | pBankID | 10 | |||
ExchRate | pDecimal | 13 | -1 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblBrJrnlHeader -- BR Journal Header table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransID | pTransID | 8 | |||
BankID | pBankID | 10 | |||
TransType | smallint | 2 | 0 | Transaction Type | 2 = Deposit, 4 = Adjustment, -1 = Disbursement, -3 = Transfer |
SourceID | nvarchar | 10 | |||
Descr | nvarchar | 30 | |||
TransDate | datetime | 8 | |||
GLPeriod | smallint | 2 | -1 | ||
FiscalYear | smallint | 2 | 0 | ||
Reference | nvarchar | 15 | |||
Amount | pDecimal | 13 | 0 | ||
AmountFgn | pDecimal | 13 | 0 | ||
CurrencyId | pCurrency | 6 | |||
ExchRate | pDecimal | 13 | -1 | ||
VoidYn | bit | 1 | 0 | ||
VoidReinstateStat | tinyint | 1 | Void Status | 0 = Released, 1 = Hold, 2 = Temporary Hold | |
Ten99Yr | tinyint | 1 | -1 | Year for 1099 Payment | 1 = Current Year, 2 = Last Year |
CreateTransaction | bit | 1 | -1 | ||
CreateManualCheck | bit | 1 | -1 | ||
PayrollMonth | smallint | 2 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblBrMaster -- BR Master table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
EntryNum | int | 4 | |||
BankID | pBankID | 10 | |||
TransType | smallint | 2 | 0 | Transaction Type | 2 = Deposit, 4 = Adjustment, -1 = Disbursement, -3 = Transfer |
SourceID | nvarchar | 10 | |||
Descr | nvarchar | 30 | |||
Reference | nvarchar | 15 | |||
SourceApp | nvarchar | 2 | |||
Amount | pDecimal | 13 | 0 | ||
AmountFgn | pDecimal | 13 | 0 | ||
TransDate | datetime | 8 | |||
FiscalYear | smallint | 2 | 0 | ||
GlPeriod | smallint | 2 | 0 | ||
ClearedYn | bit | 1 | 0 | ||
VoidTransID | pTransID | 8 | |||
VoidStop | tinyint | 1 | 0 | Transaction Status | 0 = Paid, 1 = Voided, 2 = Stopped |
CurrencyId | pCurrency | 6 | |||
ExchRate | pDecimal | 13 | -1 | ||
VoidDate | datetime | 8 | |||
VoidPd | tinyint | 1 | 0 | ||
VoidYear | smallint | 2 | 0 | ||
VoidAmt | pDecimal | 13 | 0 | ||
VoidAmtFgn | pDecimal | 13 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblBrRecurDetail -- BR Recurring Entries Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
EntryNum | int | 4 | |||
TransID | pTransID | 8 | |||
GLAcct | pGlAcct | 40 | |||
DebitAmt | pDecimal | 13 | 0 | ||
-*DebitAmtFgn | pDecimal | 13 | 0 | ||
CreditAmt | pDecimal | 13 | 0 | ||
-*CreditAmtFgn | pDecimal | 13 | 0 | ||
Descr | nvarchar | 30 | |||
Reference | nvarchar | 15 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblBrRecurHeader -- BR Recurring Entries Header table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransID | pTransID | 8 | |||
BankID | pBankID | 10 | |||
TransType | smallint | 2 | -4 | Transaction Type | 4 = Adjustment |
SourceID | nvarchar | 10 | |||
Descr | nvarchar | 30 | |||
TransDate | datetime | 8 | |||
GLPeriod | smallint | 2 | -1 | ||
FiscalYear | smallint | 2 | 0 | ||
Reference | nvarchar | 15 | |||
Amount | pDecimal | 13 | 0 | ||
-*AmountFgn | pDecimal | 13 | 0 | ||
CurrencyId | pCurrency | 6 | |||
-*ExchRate | pDecimal | 13 | -1 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblBrStatement -- BR Statement table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
BankID | pBankID | 10 | |||
BeginBalance | pDecimal | 13 | |||
BeginDate | datetime | 8 | |||
Description | pDescription | 255 | |||
EndBalance | pDecimal | 13 | |||
EndDate | datetime | 8 | |||
FiscalPeriod | smallint | 2 | |||
FiscalYear | smallint | 2 | |||
ID | bigint | 8 | |||
Reference | pDescription | 255 | |||
StatementDate | datetime | 8 | |||
Status | tinyint | 1 | Status | 0 = Open, 1 = Reconciled | |
TransCount | int | 4 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |